/*
 Navicat Premium Dump SQL

 Source Server         : nas
 Source Server Type    : MySQL
 Source Server Version : 80042 (8.0.42)
 Source Host           : 192.168.0.200:30000
 Source Schema         : sunadmin

 Target Server Type    : MySQL
 Target Server Version : 80042 (8.0.42)
 File Encoding         : 65001

 Date: 16/06/2025 09:22:24
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sunadmin_account
-- ----------------------------
DROP TABLE IF EXISTS `sunadmin_account`;
CREATE TABLE `sunadmin_account` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1' COMMENT '0=禁用1=启用',
  `online_status` tinyint(1) DEFAULT '0' COMMENT '0 = 离线 1 = 在线',
  `is_administrators` tinyint(1) DEFAULT '0' COMMENT '是否超级管理员',
  `group_id` int DEFAULT NULL COMMENT '角色组id',
  `is_del` tinyint(1) DEFAULT '0' COMMENT '1 = 已删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='管理员账号表';

-- ----------------------------
-- Records of sunadmin_account
-- ----------------------------
BEGIN;
INSERT INTO `sunadmin_account` (`id`, `username`, `avatar`, `password`, `nickname`, `remark`, `status`, `online_status`, `is_administrators`, `group_id`, `is_del`) VALUES (1, 'sunadmin', '', '$2y$10$8loTMuTi3AY25.VqFQAl2OQkRRoCu0JWb7ef1z6Z16g/enD.wkep.', '超管', '', 1, 0, 1, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for sunadmin_account_group
-- ----------------------------
DROP TABLE IF EXISTS `sunadmin_account_group`;
CREATE TABLE `sunadmin_account_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `menus_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单权限id列表，包含半开的父节点，（无法支撑前端tree组件，主要通过in查询来确定管理员菜单）',
  `tree_menus_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '不包含半开父节点的id数据，只是为了支撑前端tree组件回显',
  `add_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='管理员账号权限组';

-- ----------------------------
-- Records of sunadmin_account_group
-- ----------------------------
BEGIN;
INSERT INTO `sunadmin_account_group` (`id`, `name`, `status`, `remark`, `menus_ids`, `tree_menus_ids`, `add_time`) VALUES (6, '测试1组', 1, '但是发斯蒂芬', '[7,9,8]', '[7,9]', '2025-05-16 15:44:19');
INSERT INTO `sunadmin_account_group` (`id`, `name`, `status`, `remark`, `menus_ids`, `tree_menus_ids`, `add_time`) VALUES (7, '测试2组', 1, '发送到', '[7,8,9,10,11,12]', '[7,8,9,10,11,12]', '2025-05-24 23:09:52');
INSERT INTO `sunadmin_account_group` (`id`, `name`, `status`, `remark`, `menus_ids`, `tree_menus_ids`, `add_time`) VALUES (8, '测试3组', 0, '的说法', '[7,8,9,10,11,12,14,15,16]', '[7,8,9,10,11,12,14,15,16]', '2025-05-16 14:46:34');
COMMIT;

-- ----------------------------
-- Table structure for sunadmin_attachment
-- ----------------------------
DROP TABLE IF EXISTS `sunadmin_attachment`;
CREATE TABLE `sunadmin_attachment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `size` double DEFAULT NULL,
  `mime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类型\n',
  `ext` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '后缀',
  `disk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '保存磁盘local/public/aliyun/…',
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '存储路径，仅展示路径部分，域名部分由程序自动拼接',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '完整url',
  `add_time` datetime DEFAULT NULL,
  `uploader_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'admin / client',
  `uid` int DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类型 audio image video',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='附件';

-- ----------------------------
-- Records of sunadmin_attachment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sunadmin_data_dictionary
-- ----------------------------
DROP TABLE IF EXISTS `sunadmin_data_dictionary`;
CREATE TABLE `sunadmin_data_dictionary` (
  `id` int NOT NULL AUTO_INCREMENT,
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `data_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'input' COMMENT '数据类型''input'',''number''',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称\n',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '页面展示图标',
  `desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '说明\n',
  `sort` int DEFAULT '1' COMMENT '排序',
  `cate_id` int DEFAULT '0' COMMENT '配置所属类目id',
  `cate_id_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '前端级联选择器路径',
  `is_cate` tinyint DEFAULT '0' COMMENT '是否为分组分类目录',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='配置项数据字典';

-- ----------------------------
-- Records of sunadmin_data_dictionary
-- ----------------------------
BEGIN;
INSERT INTO `sunadmin_data_dictionary` (`id`, `key`, `value`, `data_type`, `name`, `icon`, `desc`, `sort`, `cate_id`, `cate_id_path`, `is_cate`) VALUES (21, 'system', NULL, 'input', '系统配置', 'Setting', NULL, 1, 0, NULL, 1);
INSERT INTO `sunadmin_data_dictionary` (`id`, `key`, `value`, `data_type`, `name`, `icon`, `desc`, `sort`, `cate_id`, `cate_id_path`, `is_cate`) VALUES (22, 'system_logo', 'https://lingyier.oss-cn-chengdu.aliyuncs.com/sunAdmin/20250609/52657d2e6a7f256f3830835b29b399d4.png', 'input', 'logo', NULL, NULL, 1, 21, NULL, 0);
INSERT INTO `sunadmin_data_dictionary` (`id`, `key`, `value`, `data_type`, `name`, `icon`, `desc`, `sort`, `cate_id`, `cate_id_path`, `is_cate`) VALUES (23, 'system_name', 'SunAdmin', 'input', '系统名称', NULL, NULL, 1, 21, NULL, 0);
INSERT INTO `sunadmin_data_dictionary` (`id`, `key`, `value`, `data_type`, `name`, `icon`, `desc`, `sort`, `cate_id`, `cate_id_path`, `is_cate`) VALUES (34, 'sys_main_domain', 'http://test.lingyier.com:20000', 'input', '系统域名', NULL, NULL, 1, 21, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sunadmin_filesystem_config
-- ----------------------------
DROP TABLE IF EXISTS `sunadmin_filesystem_config`;
CREATE TABLE `sunadmin_filesystem_config` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `disk_name` varchar(50) NOT NULL COMMENT '磁盘名称',
  `disk_type` varchar(20) NOT NULL COMMENT '驱动类型(local,aliyun,qiniu,qcloud等)',
  `config_data` json NOT NULL COMMENT '配置数据JSON格式',
  `logo` varchar(255) DEFAULT '0',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态(0:禁用 1:启用)',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注说明',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_disk_name` (`disk_name`),
  KEY `idx_status` (`status`),
  KEY `idx_is_default` (`logo`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='文件系统配置表';

-- ----------------------------
-- Records of sunadmin_filesystem_config
-- ----------------------------
BEGIN;
INSERT INTO `sunadmin_filesystem_config` (`id`, `disk_name`, `disk_type`, `config_data`, `logo`, `status`, `remark`, `created_at`, `updated_at`) VALUES (1, 'local', 'local', '{\"url\": \"/storage\", \"root\": \"./public/storage\", \"type\": \"local\", \"visibility\": \"public\"}', '0', 0, '本地存储', '2025-06-14 23:57:19', '2025-06-15 22:58:35');
INSERT INTO `sunadmin_filesystem_config` (`id`, `disk_name`, `disk_type`, `config_data`, `logo`, `status`, `remark`, `created_at`, `updated_at`) VALUES (2, 'aliyun', 'aliyun', '{\"type\": \"aliyun\", \"throw\": true, \"bucket\": \"lingyier\", \"cdnUrl\": null, \"prefix\": \"\", \"isCName\": false, \"options\": {\"endpoint\": \"\", \"bucket_endpoint\": \"\"}, \"endpoint\": \"oss-cn-chengdu.aliyuncs.com\", \"access_id\": \"LTAIxxxxxxxxxxxxxxx5P\", \"access_secret\": \"R0vxxxxxxxxxxxxxxx7P\"}', '0', 1, '阿里云OSS存储', '2025-06-14 23:57:19', '2025-06-16 01:21:18');
INSERT INTO `sunadmin_filesystem_config` (`id`, `disk_name`, `disk_type`, `config_data`, `logo`, `status`, `remark`, `created_at`, `updated_at`) VALUES (3, 'qiniu', 'qiniu', '{\"type\": \"qiniu\", \"bucket\": \"\", \"domain\": \"\", \"access_key\": \"\", \"secret_key\": \"\"}', '0', 0, '七牛云存储', '2025-06-14 23:57:19', '2025-06-14 23:57:19');
INSERT INTO `sunadmin_filesystem_config` (`id`, `disk_name`, `disk_type`, `config_data`, `logo`, `status`, `remark`, `created_at`, `updated_at`) VALUES (4, 'qcloud', 'qcloud', '{\"cdn\": \"\", \"type\": \"qcloud\", \"app_id\": \"\", \"bucket\": \"\", \"region\": \"\", \"scheme\": \"https\", \"timeout\": 60, \"secret_id\": \"\", \"secret_key\": \"\", \"read_from_cdn\": false, \"connect_timeout\": 60}', '0', 0, '腾讯云COS存储', '2025-06-14 23:57:19', '2025-06-14 23:57:19');
INSERT INTO `sunadmin_filesystem_config` (`id`, `disk_name`, `disk_type`, `config_data`, `logo`, `status`, `remark`, `created_at`, `updated_at`) VALUES (5, 'obs', 'obs', '{\"key\": \"\", \"root\": \"\", \"type\": \"obs\", \"bucket\": \"\", \"secret\": \"\", \"endpoint\": \"\", \"is_cname\": false, \"security_token\": \"\"}', '0', 0, '华为云OBS存储', '2025-06-14 23:57:19', '2025-06-15 09:14:55');
INSERT INTO `sunadmin_filesystem_config` (`id`, `disk_name`, `disk_type`, `config_data`, `logo`, `status`, `remark`, `created_at`, `updated_at`) VALUES (6, 's3', 's3', '{\"type\": \"s3\", \"bucket\": \"\", \"region\": \"\", \"version\": \"latest\", \"endpoint\": \"\", \"credentials\": {\"key\": \"\", \"secret\": \"\"}, \"bucket_endpoint\": false, \"use_path_style_endpoint\": false}', '0', 0, 'AWS S3存储', '2025-06-14 23:57:19', '2025-06-14 23:57:19');
INSERT INTO `sunadmin_filesystem_config` (`id`, `disk_name`, `disk_type`, `config_data`, `logo`, `status`, `remark`, `created_at`, `updated_at`) VALUES (7, 'google', 'google', '{\"type\": \"google\", \"bucket\": \"\", \"prefix\": \"\", \"project_id\": \"\"}', '0', 0, 'Google Cloud存储', '2025-06-14 23:57:19', '2025-06-15 22:55:32');
INSERT INTO `sunadmin_filesystem_config` (`id`, `disk_name`, `disk_type`, `config_data`, `logo`, `status`, `remark`, `created_at`, `updated_at`) VALUES (8, 'ftp', 'ftp', '{\"ssl\": false, \"url\": \"\", \"host\": \"\", \"port\": 21, \"root\": \"\", \"type\": \"ftp\", \"passive\": true, \"timeout\": 30, \"password\": \"\", \"username\": \"\"}', '0', 0, 'FTP存储', '2025-06-14 23:57:19', '2025-06-15 22:50:43');
INSERT INTO `sunadmin_filesystem_config` (`id`, `disk_name`, `disk_type`, `config_data`, `logo`, `status`, `remark`, `created_at`, `updated_at`) VALUES (9, 'sftp', 'sftp', '{\"url\": \"\", \"host\": \"\", \"port\": 22, \"root\": \"\", \"type\": \"sftp\", \"timeout\": 10, \"password\": \"\", \"username\": \"\", \"passphrase\": null, \"privateKey\": null}', '0', 0, 'SFTP存储', '2025-06-14 23:57:19', '2025-06-14 23:57:19');
COMMIT;

-- ----------------------------
-- Table structure for sunadmin_menus
-- ----------------------------
DROP TABLE IF EXISTS `sunadmin_menus`;
CREATE TABLE `sunadmin_menus` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类型''menu_group'',''route'',''auth''',
  `pid` int DEFAULT '0',
  `cascader_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '级联选择器路径',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `show` tinyint DEFAULT '1',
  `route_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '路由地址',
  `auth_tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '权限标识',
  `sort` int DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='后台菜单';

-- ----------------------------
-- Records of sunadmin_menus
-- ----------------------------
BEGIN;
INSERT INTO `sunadmin_menus` (`id`, `type`, `pid`, `cascader_path`, `name`, `icon`, `show`, `route_path`, `auth_tag`, `sort`) VALUES (7, 'route', 0, '[0]', '首页', 'CirclePlus', 1, '/', NULL, 1);
INSERT INTO `sunadmin_menus` (`id`, `type`, `pid`, `cascader_path`, `name`, `icon`, `show`, `route_path`, `auth_tag`, `sort`) VALUES (8, 'menu_group', 0, '[0]', '运维', 'Cpu', 1, '/maintenance', NULL, 99);
INSERT INTO `sunadmin_menus` (`id`, `type`, `pid`, `cascader_path`, `name`, `icon`, `show`, `route_path`, `auth_tag`, `sort`) VALUES (9, 'route', 8, '[8]', '菜单权限', 'Document', 1, '/maintenance/menus', NULL, 1);
INSERT INTO `sunadmin_menus` (`id`, `type`, `pid`, `cascader_path`, `name`, `icon`, `show`, `route_path`, `auth_tag`, `sort`) VALUES (10, 'route', 8, '[8]', '数据字典', 'SetUp', 1, '/maintenance/dataDictionary', NULL, 2);
INSERT INTO `sunadmin_menus` (`id`, `type`, `pid`, `cascader_path`, `name`, `icon`, `show`, `route_path`, `auth_tag`, `sort`) VALUES (11, 'route', 8, '[8]', '附件管理', 'Files', 1, '/maintenance/attachment', NULL, 3);
INSERT INTO `sunadmin_menus` (`id`, `type`, `pid`, `cascader_path`, `name`, `icon`, `show`, `route_path`, `auth_tag`, `sort`) VALUES (12, 'route', 8, '[8]', '管理员账号', 'User', 1, '/maintenance/account', NULL, 4);
INSERT INTO `sunadmin_menus` (`id`, `type`, `pid`, `cascader_path`, `name`, `icon`, `show`, `route_path`, `auth_tag`, `sort`) VALUES (25, 'route', 8, '[8]', '定时任务管理', 'AlarmClock', 1, '/maintenance/timerTaskManage', NULL, 5);
COMMIT;

-- ----------------------------
-- Table structure for sunadmin_operation_log
-- ----------------------------
DROP TABLE IF EXISTS `sunadmin_operation_log`;
CREATE TABLE `sunadmin_operation_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `admin_id` int unsigned NOT NULL DEFAULT '0' COMMENT '操作人ID',
  `action` varchar(100) NOT NULL DEFAULT '' COMMENT '操作类型',
  `content` text COMMENT '操作内容',
  `ip` varchar(45) NOT NULL DEFAULT '' COMMENT '操作IP',
  `user_agent` varchar(255) NOT NULL DEFAULT '' COMMENT 'UA信息',
  `created_at` datetime NOT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='后台操作日志';

-- ----------------------------
-- Records of sunadmin_operation_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sunadmin_timer_task
-- ----------------------------
DROP TABLE IF EXISTS `sunadmin_timer_task`;
CREATE TABLE `sunadmin_timer_task` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务名称（标识），仅为英文字符，不可重复，必填',
  `desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '任务描述',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '调度类型，interval = 间隔执行  daily = 每日',
  `schedule_config` json DEFAULT NULL COMMENT '调度配置',
  `class_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行类名，包含完整的命名空间',
  `method_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行方法名',
  `failed_executions` int DEFAULT '0' COMMENT '失败次数',
  `add_time` datetime DEFAULT NULL,
  `last_run_time` datetime DEFAULT NULL COMMENT '最后执行时间',
  `next_run_time` datetime DEFAULT NULL COMMENT '下一次执行时间',
  `enabled` tinyint(1) DEFAULT '1' COMMENT '是否启用：1=启用，0=禁用',
  `run_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'stop' COMMENT 'Stop  running',
  `log_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'full' COMMENT 'full =完整 error_only = 仅记录错误\n',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sunadmin_timer_task
-- ----------------------------
BEGIN;
INSERT INTO `sunadmin_timer_task` (`id`, `name`, `desc`, `type`, `schedule_config`, `class_name`, `method_name`, `failed_executions`, `add_time`, `last_run_time`, `next_run_time`, `enabled`, `run_status`, `log_level`) VALUES (2, 'SystemMetricsJob', '定时收集cpu、内存等信息，并ws广播给所有后台', 'interval', '{\"interval\": 1}', 'SunAdmin\\Task\\jobs\\SystemMetricsJob', 'run', 0, '2025-06-15 09:18:17', '2025-06-16 09:22:24', NULL, 1, 'success', 'error_only');
INSERT INTO `sunadmin_timer_task` (`id`, `name`, `desc`, `type`, `schedule_config`, `class_name`, `method_name`, `failed_executions`, `add_time`, `last_run_time`, `next_run_time`, `enabled`, `run_status`, `log_level`) VALUES (5, 'ClearLogJob', '定时清理日志', 'daily', '{\"time\": \"05:00\"}', 'SunAdmin\\Task\\jobs\\ClearLogJob', 'run', 0, '2025-06-11 01:01:09', '2025-06-15 05:00:47', NULL, 1, 'success', 'full');
COMMIT;

-- ----------------------------
-- Table structure for sunadmin_timer_task_log
-- ----------------------------
DROP TABLE IF EXISTS `sunadmin_timer_task_log`;
CREATE TABLE `sunadmin_timer_task_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `task_id` int DEFAULT NULL,
  `exec_time` int DEFAULT NULL COMMENT '执行消耗时间',
  `exec_memory` float DEFAULT NULL COMMENT '执行消耗内存',
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1' COMMENT '1 = 成功 0 = 失败',
  `add_time` datetime DEFAULT NULL,
  `message` json DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sunadmin_timer_task_log
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
